---
title: DB-CLL-003 — Update case cost amounts and details
summary: Update case cost amounts and details
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-003 — Update case cost amounts and details

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-003 |
| Operation type | U |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsCaseCost |
| Criteria property | UpdateSQL |
| Lifecycle method | BeforeUpdate |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier the cost line belongs to |
| PayeeFirmProvLocID | Input | NUMBER | N/A | Payee firm provider-location identifier |
| PayeePersonProvLocID | Input | NUMBER | N/A | Payee person provider-location identifier |
| ServiceFromDate | Input | DATE | N/A | Start of the billed service period |
| ServiceToDate | Input | DATE | N/A | End of the billed service period |
| ServiceCode | Input | VARCHAR2 | N/A | Code identifying the type of service billed |
| AmountPaid | Input | NUMBER | N/A | Amount paid for the service |
| AuthorizerEmplid | Input | VARCHAR2 | N/A | Employee ID of the person who authorized the cost |
| AuthorizedDate | Input | DATE | N/A | Date the cost was authorized |
| AmountBilled | Input | NUMBER | N/A | Amount billed by the payee |
| PrepaymentFlag | Input | VARCHAR2 | 1 | Indicates the cost is a prepayment |
| CancelledByCode | Input | VARCHAR2 | N/A | Code identifying who cancelled the cost, if cancelled |
| CreateDate | Input | DATE | N/A | Row creation timestamp |
| CreateUser | Input | VARCHAR2 | N/A | User who created the row |
| UpdateDate | Input | DATE | N/A | Row last-update timestamp |
| UpdateUser | Input | VARCHAR2 | N/A | User who last updated the row |
| AmountPerHour | Input | NUMBER | N/A | Hourly billing rate, if applicable |
| HoursBilled | Input | NUMBER | N/A | Number of hours billed |
| CaseCostID | Input | NUMBER | N/A | Primary key of the row to update |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [CASE_COST](../database-tables.md#case_cost) | UPDATE | 17 non-key columns, filtered by CASE_COST_SEQ_NUM |

## Sample SQL

```sql
Update CASE_COST
Set
  PAYEE_FIRM_PROV_LOC_ID = :PayeeFirmProvLocID,
  PAYEE_PERSON_PROV_LOC_ID = :PayeePersonProvLocID,
  SERVICE_FROM_DATE = :ServiceFromDate,
  SERVICE_TO_DATE = :ServiceToDate,
  SERVICE_CODE = :ServiceCode,
  AMOUNT_PAID = :AmountPaid,
  AUTHORIZER_EMPLID = :AuthorizerEmplid,
  AUTHORIZED_DATE = :AuthorizedDate,
  AMOUNT_BILLED = :AmountBilled,
  PREPAYMENT_FLAG = :PrepaymentFlag,
  CANCELLED_BY_CODE = :CancelledByCode,
  UPDATE_DATE = :UpdateDate,
  UPDATE_USER = :UpdateUser,
  AMOUNT_PER_HOUR = :AmountPerHour,
  HOURS_BILLED = :HoursBilled
Where
  CASE_COST.CASE_COST_SEQ_NUM = :CaseCostID
```

## Operations and processes

- [Manage case cost entries](../operations/manage-case-cost.md)

## Business rules

- [BR-CLM-LGL-001](../business-rules.md#br-clm-lgl-001-case-cost-date-ranges-must-be-valid)
- [BR-CLM-LGL-002](../business-rules.md#br-clm-lgl-002-case-cost-entry-requires-a-payee)
- [BR-CLM-LGL-003](../business-rules.md#br-clm-lgl-003-case-cost-entry-requires-service-code%2C-authorizer%2C-and-canceller)
- [BR-CLM-LGL-005](../business-rules.md#br-clm-lgl-005-non-single-row-crud-result-is-treated-as-a-failure)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsCaseCost.vb`